| Key Name |
Key Type |
Keys |
| AdEnrollSched_Status_adDependentClassSchedID_AdEnrollSchedID_U_N_IDX |
Alternate Key |
Status, DependentClassSectionId, StudentCourseId |
| AdEnrollSched_AdEnrollID_Status_EndDate_AdCourseID_GPACalc_RetakeOverride_N_N_IDX |
Inversion Entry |
StudentCourseId, Status, EndDate, IsIncludedInGpaCalc, RetakeOverride |
| Nk_AdEnrollSchedAmTransferTypeID |
Inversion Entry |
TransferTypeId |
| AdEnrollSched_AdClassSchedId_Status_AfterAddDrop_N_N_idx |
Inversion Entry |
Id_2, Status, IsAfterAddDrop |
| AdEnrollSched_AdEnrollID_AdTermID_Status_Credits_CreditsAttempt_Hours_INCLUDE_N_N_IDX |
Inversion Entry |
StudentCourseId, Status, CreditHours, CreditHoursAttempted, ClockHours |
| AdEnrollSched_SyStudentID_StartDate_N_N_IDX |
Inversion Entry |
StartDate |
| AdEnrollSched_AdEnrollID_Status_GPACAlc_TransferCredit_RetakeOverRide_N_N_idx |
Inversion Entry |
StudentCourseId, Status, IsIncludedInGpaCalc, IsTransferCredit, RetakeOverride |
| NK_AdEnrollSched_AdEnrollID_Status_AdProgramCourseID_INCL |
Inversion Entry |
StudentCourseId, Status |
| NK_AdEnrollSchedAdEnrollIDAdCourseID |
Inversion Entry |
StudentCourseId |
| AdEnrollSched_Status_AdTermID_AdEnrollID_N_N_IDX |
Inversion Entry |
Status, StudentCourseId |
| AdEnrollSched_AdEnrollID_AdClassSchedID_AdCourseID_N_N_IDX |
Inversion Entry |
StudentCourseId, Id_2 |
| AdEnrollSched_AmCollegeTransferID_N_N_IDX |
Inversion Entry |
StudentTransferCreditId |
| AdEnrollSched_AdEnrollID_AdTermID_StartDate_DropDate_EndDate_ExpectedEndDate_Status_AdClassSchedID_AdEnrollSchedID_U_N_IDX |
Alternate Key |
StudentCourseId, StartDate, DropDate, EndDate, ExpectedEndDate, Status, Id_2 |
| AdEnrollSched_AdGradeLetterCode_N_N_IDX |
Inversion Entry |
LetterGrade |
| AdEnrollSched_AdCourseID_N_N_IDX |
Inversion Entry |
StudentCourseId |
| AdEnrollSched_RevenueRefNo_AdEnrollId_N_N_idx |
Inversion Entry |
RevenueReferenceNumber, StudentCourseId |
| AdEnrollSched_AdEnrollSchedID_U_C_IDX |
PrimaryKey |
StudentCourseId |
| AdEnrollSched_StartDate_SyStudentID_N_N_idx |
Inversion Entry |
StartDate |
| AdEnrollSched_SyStudentID_AdClassSchedId_AdEnrollSchedId_U_N_IDX |
Inversion Entry |
Id_2, StudentCourseId |
| adenrollsched_FaStudentAyPaymentPeriodId_N_N_IDX |
Inversion Entry |
FaStudentAyPaymentPeriodId |
| Nk_AdEnrollSchedAmHighSchoolID |
Inversion Entry |
HighSchoolId |
| AdEnrollSched_ModFlag_N_N_IDX |
Inversion Entry |
ModFlag |
| AdEnrollSched_SyStudentID_Status_AdCourseID_N_N_IDX |
Inversion Entry |
Status, StudentCourseId |
| AdEnrollSched_AdClassSchedId_AdTermID_IDX |
Inversion Entry |
Id_2 |
| AdEnrollSched_AdTermID_AdEnrollSchedId_AdEnrollID_Status_SyStudentId_AdCourseId_U_N_IDX |
Alternate Key |
StudentCourseId, Status |
| Entity Name |
Type |
Cardinality |
Business Name |
VerbPhrase |
InversePhrase |
Foreign Keys |
Is Supertype |
| RequiredCourse |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
RequiredCourseId |
NO |
| ClassSection |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
ClassSectionId |
NO |
| Course |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
CourseId |
NO |
| StudentTransferCredit |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentTransferCreditId |
NO |
| CourseFeeSchedule |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
CourseFeeScheduleId |
NO |
| StudentEnrollmentPeriod |
Non-Identifying |
One To Zero or More |
|
|
|
StudentCourseId |
NO |
| StudentCoursePendingRegistration |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
Id_2 |
NO |
| StudentAcademicYearPaymentPeriod |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
FaStudentAyPaymentPeriodId |
NO |
| HighSchool |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
HighSchoolId |
NO |
| TransferCreditType |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
TransferTypeId |
NO |
| GradeScale |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
GradeScaleId |
NO |
| RequiredCourse |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
RequiredCourseId |
NO |
| Student |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentId |
NO |
| StudentEnrollmentPeriod |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentEnrollmentPeriodId |
NO |
| Term |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
TermId |
NO |